Overview

Dataset statistics

Number of variables17
Number of observations1000
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory132.9 KiB
Average record size in memory136.1 B

Variable types

Text1
Categorical7
Numeric7
DateTime2

Alerts

gross margin percentage has constant value ""Constant
Invoice ID has unique valuesUnique

Reproduction

Analysis started2024-04-23 09:57:39.849544
Analysis finished2024-04-23 09:57:45.875833
Duration6.03 seconds
Software versionydata-profiling vv4.7.0
Download configurationconfig.json

Variables

Invoice ID
Text

UNIQUE 

Distinct1000
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size7.9 KiB
2024-04-23T15:27:46.241077image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/

Length

Max length11
Median length11
Mean length11
Min length11

Characters and Unicode

Total characters11000
Distinct characters11
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique1000 ?
Unique (%)100.0%

Sample

1st row750-67-8428
2nd row226-31-3081
3rd row631-41-3108
4th row123-19-1176
5th row373-73-7910
ValueCountFrequency (%)
750-67-8428 1
 
0.1%
252-56-2699 1
 
0.1%
871-79-8483 1
 
0.1%
848-62-7243 1
 
0.1%
631-41-3108 1
 
0.1%
123-19-1176 1
 
0.1%
373-73-7910 1
 
0.1%
699-14-3026 1
 
0.1%
355-53-5943 1
 
0.1%
315-22-5665 1
 
0.1%
Other values (990) 990
99.0%
2024-04-23T15:27:46.641516image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 2000
18.2%
2 957
8.7%
6 954
8.7%
1 950
8.6%
8 944
8.6%
5 927
8.4%
4 918
8.3%
3 909
8.3%
7 895
8.1%
0 809
7.4%

Most occurring categories

ValueCountFrequency (%)
(unknown) 11000
100.0%

Most frequent character per category

(unknown)
ValueCountFrequency (%)
- 2000
18.2%
2 957
8.7%
6 954
8.7%
1 950
8.6%
8 944
8.6%
5 927
8.4%
4 918
8.3%
3 909
8.3%
7 895
8.1%
0 809
7.4%

Most occurring scripts

ValueCountFrequency (%)
(unknown) 11000
100.0%

Most frequent character per script

(unknown)
ValueCountFrequency (%)
- 2000
18.2%
2 957
8.7%
6 954
8.7%
1 950
8.6%
8 944
8.6%
5 927
8.4%
4 918
8.3%
3 909
8.3%
7 895
8.1%
0 809
7.4%

Most occurring blocks

ValueCountFrequency (%)
(unknown) 11000
100.0%

Most frequent character per block

(unknown)
ValueCountFrequency (%)
- 2000
18.2%
2 957
8.7%
6 954
8.7%
1 950
8.6%
8 944
8.6%
5 927
8.4%
4 918
8.3%
3 909
8.3%
7 895
8.1%
0 809
7.4%

Branch
Categorical

Distinct3
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size7.9 KiB
A
340 
B
332 
C
328 

Length

Max length1
Median length1
Mean length1
Min length1

Characters and Unicode

Total characters1000
Distinct characters3
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowA
2nd rowC
3rd rowA
4th rowA
5th rowA

Common Values

ValueCountFrequency (%)
A 340
34.0%
B 332
33.2%
C 328
32.8%

Length

2024-04-23T15:27:46.776963image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-23T15:27:46.874665image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
ValueCountFrequency (%)
a 340
34.0%
b 332
33.2%
c 328
32.8%

Most occurring characters

ValueCountFrequency (%)
A 340
34.0%
B 332
33.2%
C 328
32.8%

Most occurring categories

ValueCountFrequency (%)
(unknown) 1000
100.0%

Most frequent character per category

(unknown)
ValueCountFrequency (%)
A 340
34.0%
B 332
33.2%
C 328
32.8%

Most occurring scripts

ValueCountFrequency (%)
(unknown) 1000
100.0%

Most frequent character per script

(unknown)
ValueCountFrequency (%)
A 340
34.0%
B 332
33.2%
C 328
32.8%

Most occurring blocks

ValueCountFrequency (%)
(unknown) 1000
100.0%

Most frequent character per block

(unknown)
ValueCountFrequency (%)
A 340
34.0%
B 332
33.2%
C 328
32.8%

City
Categorical

Distinct3
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size7.9 KiB
Yangon
340 
Mandalay
332 
Naypyitaw
328 

Length

Max length9
Median length8
Mean length7.648
Min length6

Characters and Unicode

Total characters7648
Distinct characters14
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowYangon
2nd rowNaypyitaw
3rd rowYangon
4th rowYangon
5th rowYangon

Common Values

ValueCountFrequency (%)
Yangon 340
34.0%
Mandalay 332
33.2%
Naypyitaw 328
32.8%

Length

2024-04-23T15:27:46.977681image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-23T15:27:47.081666image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
ValueCountFrequency (%)
yangon 340
34.0%
mandalay 332
33.2%
naypyitaw 328
32.8%

Most occurring characters

ValueCountFrequency (%)
a 1992
26.0%
n 1012
13.2%
y 988
12.9%
Y 340
 
4.4%
g 340
 
4.4%
o 340
 
4.4%
M 332
 
4.3%
d 332
 
4.3%
l 332
 
4.3%
N 328
 
4.3%
Other values (4) 1312
17.2%

Most occurring categories

ValueCountFrequency (%)
(unknown) 7648
100.0%

Most frequent character per category

(unknown)
ValueCountFrequency (%)
a 1992
26.0%
n 1012
13.2%
y 988
12.9%
Y 340
 
4.4%
g 340
 
4.4%
o 340
 
4.4%
M 332
 
4.3%
d 332
 
4.3%
l 332
 
4.3%
N 328
 
4.3%
Other values (4) 1312
17.2%

Most occurring scripts

ValueCountFrequency (%)
(unknown) 7648
100.0%

Most frequent character per script

(unknown)
ValueCountFrequency (%)
a 1992
26.0%
n 1012
13.2%
y 988
12.9%
Y 340
 
4.4%
g 340
 
4.4%
o 340
 
4.4%
M 332
 
4.3%
d 332
 
4.3%
l 332
 
4.3%
N 328
 
4.3%
Other values (4) 1312
17.2%

Most occurring blocks

ValueCountFrequency (%)
(unknown) 7648
100.0%

Most frequent character per block

(unknown)
ValueCountFrequency (%)
a 1992
26.0%
n 1012
13.2%
y 988
12.9%
Y 340
 
4.4%
g 340
 
4.4%
o 340
 
4.4%
M 332
 
4.3%
d 332
 
4.3%
l 332
 
4.3%
N 328
 
4.3%
Other values (4) 1312
17.2%

Customer type
Categorical

Distinct2
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size7.9 KiB
Member
501 
Normal
499 

Length

Max length6
Median length6
Mean length6
Min length6

Characters and Unicode

Total characters6000
Distinct characters9
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowMember
2nd rowNormal
3rd rowNormal
4th rowMember
5th rowNormal

Common Values

ValueCountFrequency (%)
Member 501
50.1%
Normal 499
49.9%

Length

2024-04-23T15:27:47.186313image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-23T15:27:47.275464image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
ValueCountFrequency (%)
member 501
50.1%
normal 499
49.9%

Most occurring characters

ValueCountFrequency (%)
e 1002
16.7%
m 1000
16.7%
r 1000
16.7%
M 501
8.3%
b 501
8.3%
N 499
8.3%
o 499
8.3%
a 499
8.3%
l 499
8.3%

Most occurring categories

ValueCountFrequency (%)
(unknown) 6000
100.0%

Most frequent character per category

(unknown)
ValueCountFrequency (%)
e 1002
16.7%
m 1000
16.7%
r 1000
16.7%
M 501
8.3%
b 501
8.3%
N 499
8.3%
o 499
8.3%
a 499
8.3%
l 499
8.3%

Most occurring scripts

ValueCountFrequency (%)
(unknown) 6000
100.0%

Most frequent character per script

(unknown)
ValueCountFrequency (%)
e 1002
16.7%
m 1000
16.7%
r 1000
16.7%
M 501
8.3%
b 501
8.3%
N 499
8.3%
o 499
8.3%
a 499
8.3%
l 499
8.3%

Most occurring blocks

ValueCountFrequency (%)
(unknown) 6000
100.0%

Most frequent character per block

(unknown)
ValueCountFrequency (%)
e 1002
16.7%
m 1000
16.7%
r 1000
16.7%
M 501
8.3%
b 501
8.3%
N 499
8.3%
o 499
8.3%
a 499
8.3%
l 499
8.3%

Gender
Categorical

Distinct2
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size7.9 KiB
Female
501 
Male
499 

Length

Max length6
Median length6
Mean length5.002
Min length4

Characters and Unicode

Total characters5002
Distinct characters6
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowFemale
2nd rowFemale
3rd rowMale
4th rowMale
5th rowMale

Common Values

ValueCountFrequency (%)
Female 501
50.1%
Male 499
49.9%

Length

2024-04-23T15:27:47.380047image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-23T15:27:47.479304image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
ValueCountFrequency (%)
female 501
50.1%
male 499
49.9%

Most occurring characters

ValueCountFrequency (%)
e 1501
30.0%
a 1000
20.0%
l 1000
20.0%
F 501
 
10.0%
m 501
 
10.0%
M 499
 
10.0%

Most occurring categories

ValueCountFrequency (%)
(unknown) 5002
100.0%

Most frequent character per category

(unknown)
ValueCountFrequency (%)
e 1501
30.0%
a 1000
20.0%
l 1000
20.0%
F 501
 
10.0%
m 501
 
10.0%
M 499
 
10.0%

Most occurring scripts

ValueCountFrequency (%)
(unknown) 5002
100.0%

Most frequent character per script

(unknown)
ValueCountFrequency (%)
e 1501
30.0%
a 1000
20.0%
l 1000
20.0%
F 501
 
10.0%
m 501
 
10.0%
M 499
 
10.0%

Most occurring blocks

ValueCountFrequency (%)
(unknown) 5002
100.0%

Most frequent character per block

(unknown)
ValueCountFrequency (%)
e 1501
30.0%
a 1000
20.0%
l 1000
20.0%
F 501
 
10.0%
m 501
 
10.0%
M 499
 
10.0%

Product line
Categorical

Distinct6
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size7.9 KiB
Fashion accessories
178 
Food and beverages
174 
Electronic accessories
170 
Sports and travel
166 
Home and lifestyle
160 

Length

Max length22
Median length19
Mean length18.54
Min length17

Characters and Unicode

Total characters18540
Distinct characters25
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowHealth and beauty
2nd rowElectronic accessories
3rd rowHome and lifestyle
4th rowHealth and beauty
5th rowSports and travel

Common Values

ValueCountFrequency (%)
Fashion accessories 178
17.8%
Food and beverages 174
17.4%
Electronic accessories 170
17.0%
Sports and travel 166
16.6%
Home and lifestyle 160
16.0%
Health and beauty 152
15.2%

Length

2024-04-23T15:27:47.583679image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-23T15:27:47.691504image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
ValueCountFrequency (%)
and 652
24.6%
accessories 348
13.1%
fashion 178
 
6.7%
food 174
 
6.6%
beverages 174
 
6.6%
electronic 170
 
6.4%
sports 166
 
6.3%
travel 166
 
6.3%
home 160
 
6.0%
lifestyle 160
 
6.0%
Other values (2) 304
11.5%

Most occurring characters

ValueCountFrequency (%)
e 2338
12.6%
a 1822
 
9.8%
s 1722
 
9.3%
1652
 
8.9%
o 1370
 
7.4%
c 1036
 
5.6%
r 1024
 
5.5%
n 1000
 
5.4%
t 966
 
5.2%
i 856
 
4.6%
Other values (15) 4754
25.6%

Most occurring categories

ValueCountFrequency (%)
(unknown) 18540
100.0%

Most frequent character per category

(unknown)
ValueCountFrequency (%)
e 2338
12.6%
a 1822
 
9.8%
s 1722
 
9.3%
1652
 
8.9%
o 1370
 
7.4%
c 1036
 
5.6%
r 1024
 
5.5%
n 1000
 
5.4%
t 966
 
5.2%
i 856
 
4.6%
Other values (15) 4754
25.6%

Most occurring scripts

ValueCountFrequency (%)
(unknown) 18540
100.0%

Most frequent character per script

(unknown)
ValueCountFrequency (%)
e 2338
12.6%
a 1822
 
9.8%
s 1722
 
9.3%
1652
 
8.9%
o 1370
 
7.4%
c 1036
 
5.6%
r 1024
 
5.5%
n 1000
 
5.4%
t 966
 
5.2%
i 856
 
4.6%
Other values (15) 4754
25.6%

Most occurring blocks

ValueCountFrequency (%)
(unknown) 18540
100.0%

Most frequent character per block

(unknown)
ValueCountFrequency (%)
e 2338
12.6%
a 1822
 
9.8%
s 1722
 
9.3%
1652
 
8.9%
o 1370
 
7.4%
c 1036
 
5.6%
r 1024
 
5.5%
n 1000
 
5.4%
t 966
 
5.2%
i 856
 
4.6%
Other values (15) 4754
25.6%

Unit price
Real number (ℝ)

Distinct943
Distinct (%)94.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean55.67213
Minimum10.08
Maximum99.96
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size7.9 KiB
2024-04-23T15:27:47.864122image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/

Quantile statistics

Minimum10.08
5-th percentile15.279
Q132.875
median55.23
Q377.935
95-th percentile97.222
Maximum99.96
Range89.88
Interquartile range (IQR)45.06

Descriptive statistics

Standard deviation26.494628
Coefficient of variation (CV)0.4759047
Kurtosis-1.2185914
Mean55.67213
Median Absolute Deviation (MAD)22.505
Skewness0.0070774479
Sum55672.13
Variance701.96533
MonotonicityNot monotonic
2024-04-23T15:27:48.017445image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
83.77 3
 
0.3%
39.62 2
 
0.2%
24.74 2
 
0.2%
19.15 2
 
0.2%
73.47 2
 
0.2%
95.54 2
 
0.2%
78.31 2
 
0.2%
26.26 2
 
0.2%
89.48 2
 
0.2%
72.88 2
 
0.2%
Other values (933) 979
97.9%
ValueCountFrequency (%)
10.08 1
0.1%
10.13 1
0.1%
10.16 1
0.1%
10.17 1
0.1%
10.18 1
0.1%
10.53 1
0.1%
10.56 1
0.1%
10.59 1
0.1%
10.69 1
0.1%
10.75 1
0.1%
ValueCountFrequency (%)
99.96 2
0.2%
99.92 1
0.1%
99.89 1
0.1%
99.83 1
0.1%
99.82 2
0.2%
99.79 1
0.1%
99.78 1
0.1%
99.73 1
0.1%
99.71 1
0.1%
99.7 1
0.1%

Quantity
Real number (ℝ)

Distinct10
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean5.51
Minimum1
Maximum10
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size7.9 KiB
2024-04-23T15:27:48.154881image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q13
median5
Q38
95-th percentile10
Maximum10
Range9
Interquartile range (IQR)5

Descriptive statistics

Standard deviation2.9234306
Coefficient of variation (CV)0.53056817
Kurtosis-1.2155472
Mean5.51
Median Absolute Deviation (MAD)2
Skewness0.012941048
Sum5510
Variance8.5464464
MonotonicityNot monotonic
2024-04-23T15:27:48.260642image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%)
10 119
11.9%
1 112
11.2%
4 109
10.9%
7 102
10.2%
5 102
10.2%
6 98
9.8%
9 92
9.2%
2 91
9.1%
3 90
9.0%
8 85
8.5%
ValueCountFrequency (%)
1 112
11.2%
2 91
9.1%
3 90
9.0%
4 109
10.9%
5 102
10.2%
6 98
9.8%
7 102
10.2%
8 85
8.5%
9 92
9.2%
10 119
11.9%
ValueCountFrequency (%)
10 119
11.9%
9 92
9.2%
8 85
8.5%
7 102
10.2%
6 98
9.8%
5 102
10.2%
4 109
10.9%
3 90
9.0%
2 91
9.1%
1 112
11.2%

Tax 5%
Real number (ℝ)

Distinct990
Distinct (%)99.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean15.379369
Minimum0.5085
Maximum49.65
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size7.9 KiB
2024-04-23T15:27:48.392006image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/

Quantile statistics

Minimum0.5085
5-th percentile1.955725
Q15.924875
median12.088
Q322.44525
95-th percentile39.1665
Maximum49.65
Range49.1415
Interquartile range (IQR)16.520375

Descriptive statistics

Standard deviation11.708825
Coefficient of variation (CV)0.76133328
Kurtosis-0.081884758
Mean15.379369
Median Absolute Deviation (MAD)7.50875
Skewness0.8925698
Sum15379.369
Variance137.09659
MonotonicityNot monotonic
2024-04-23T15:27:48.550996image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
10.326 2
 
0.2%
4.464 2
 
0.2%
4.154 2
 
0.2%
9.0045 2
 
0.2%
22.428 2
 
0.2%
39.48 2
 
0.2%
10.3635 2
 
0.2%
8.377 2
 
0.2%
13.188 2
 
0.2%
12.57 2
 
0.2%
Other values (980) 980
98.0%
ValueCountFrequency (%)
0.5085 1
0.1%
0.6045 1
0.1%
0.627 1
0.1%
0.639 1
0.1%
0.699 1
0.1%
0.767 1
0.1%
0.7715 1
0.1%
0.775 1
0.1%
0.814 1
0.1%
0.8875 1
0.1%
ValueCountFrequency (%)
49.65 1
0.1%
49.49 1
0.1%
49.26 1
0.1%
48.75 1
0.1%
48.69 1
0.1%
48.685 1
0.1%
48.605 1
0.1%
47.79 1
0.1%
47.72 1
0.1%
45.325 1
0.1%

Total
Real number (ℝ)

Distinct990
Distinct (%)99.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean322.96675
Minimum10.6785
Maximum1042.65
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size7.9 KiB
2024-04-23T15:27:48.709570image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/

Quantile statistics

Minimum10.6785
5-th percentile41.070225
Q1124.42238
median253.848
Q3471.35025
95-th percentile822.4965
Maximum1042.65
Range1031.9715
Interquartile range (IQR)346.92787

Descriptive statistics

Standard deviation245.88534
Coefficient of variation (CV)0.76133328
Kurtosis-0.081884758
Mean322.96675
Median Absolute Deviation (MAD)157.68375
Skewness0.8925698
Sum322966.75
Variance60459.598
MonotonicityNot monotonic
2024-04-23T15:27:48.841878image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
216.846 2
 
0.2%
93.744 2
 
0.2%
87.234 2
 
0.2%
189.0945 2
 
0.2%
470.988 2
 
0.2%
829.08 2
 
0.2%
217.6335 2
 
0.2%
175.917 2
 
0.2%
276.948 2
 
0.2%
263.97 2
 
0.2%
Other values (980) 980
98.0%
ValueCountFrequency (%)
10.6785 1
0.1%
12.6945 1
0.1%
13.167 1
0.1%
13.419 1
0.1%
14.679 1
0.1%
16.107 1
0.1%
16.2015 1
0.1%
16.275 1
0.1%
17.094 1
0.1%
18.6375 1
0.1%
ValueCountFrequency (%)
1042.65 1
0.1%
1039.29 1
0.1%
1034.46 1
0.1%
1023.75 1
0.1%
1022.49 1
0.1%
1022.385 1
0.1%
1020.705 1
0.1%
1003.59 1
0.1%
1002.12 1
0.1%
951.825 1
0.1%

Date
Date

Distinct89
Distinct (%)8.9%
Missing0
Missing (%)0.0%
Memory size7.9 KiB
Minimum2019-01-01 00:00:00
Maximum2019-03-30 00:00:00
2024-04-23T15:27:48.981447image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
2024-04-23T15:27:49.142602image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

Time
Date

Distinct506
Distinct (%)50.6%
Missing0
Missing (%)0.0%
Memory size7.9 KiB
Minimum2024-04-23 10:00:00
Maximum2024-04-23 20:59:00
2024-04-23T15:27:49.313312image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
2024-04-23T15:27:49.589339image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

Payment
Categorical

Distinct3
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size7.9 KiB
Ewallet
345 
Cash
344 
Credit card
311 

Length

Max length11
Median length7
Mean length7.212
Min length4

Characters and Unicode

Total characters7212
Distinct characters14
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowEwallet
2nd rowCash
3rd rowCredit card
4th rowEwallet
5th rowEwallet

Common Values

ValueCountFrequency (%)
Ewallet 345
34.5%
Cash 344
34.4%
Credit card 311
31.1%

Length

2024-04-23T15:27:49.727151image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-23T15:27:49.832299image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
ValueCountFrequency (%)
ewallet 345
26.3%
cash 344
26.2%
credit 311
23.7%
card 311
23.7%

Most occurring characters

ValueCountFrequency (%)
a 1000
13.9%
l 690
9.6%
e 656
9.1%
t 656
9.1%
C 655
9.1%
r 622
8.6%
d 622
8.6%
E 345
 
4.8%
w 345
 
4.8%
s 344
 
4.8%
Other values (4) 1277
17.7%

Most occurring categories

ValueCountFrequency (%)
(unknown) 7212
100.0%

Most frequent character per category

(unknown)
ValueCountFrequency (%)
a 1000
13.9%
l 690
9.6%
e 656
9.1%
t 656
9.1%
C 655
9.1%
r 622
8.6%
d 622
8.6%
E 345
 
4.8%
w 345
 
4.8%
s 344
 
4.8%
Other values (4) 1277
17.7%

Most occurring scripts

ValueCountFrequency (%)
(unknown) 7212
100.0%

Most frequent character per script

(unknown)
ValueCountFrequency (%)
a 1000
13.9%
l 690
9.6%
e 656
9.1%
t 656
9.1%
C 655
9.1%
r 622
8.6%
d 622
8.6%
E 345
 
4.8%
w 345
 
4.8%
s 344
 
4.8%
Other values (4) 1277
17.7%

Most occurring blocks

ValueCountFrequency (%)
(unknown) 7212
100.0%

Most frequent character per block

(unknown)
ValueCountFrequency (%)
a 1000
13.9%
l 690
9.6%
e 656
9.1%
t 656
9.1%
C 655
9.1%
r 622
8.6%
d 622
8.6%
E 345
 
4.8%
w 345
 
4.8%
s 344
 
4.8%
Other values (4) 1277
17.7%

cogs
Real number (ℝ)

Distinct990
Distinct (%)99.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean307.58738
Minimum10.17
Maximum993
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size7.9 KiB
2024-04-23T15:27:49.970057image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/

Quantile statistics

Minimum10.17
5-th percentile39.1145
Q1118.4975
median241.76
Q3448.905
95-th percentile783.33
Maximum993
Range982.83
Interquartile range (IQR)330.4075

Descriptive statistics

Standard deviation234.17651
Coefficient of variation (CV)0.76133328
Kurtosis-0.081884758
Mean307.58738
Median Absolute Deviation (MAD)150.175
Skewness0.8925698
Sum307587.38
Variance54838.638
MonotonicityNot monotonic
2024-04-23T15:27:50.092435image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
206.52 2
 
0.2%
89.28 2
 
0.2%
83.08 2
 
0.2%
180.09 2
 
0.2%
448.56 2
 
0.2%
789.6 2
 
0.2%
207.27 2
 
0.2%
167.54 2
 
0.2%
263.76 2
 
0.2%
251.4 2
 
0.2%
Other values (980) 980
98.0%
ValueCountFrequency (%)
10.17 1
0.1%
12.09 1
0.1%
12.54 1
0.1%
12.78 1
0.1%
13.98 1
0.1%
15.34 1
0.1%
15.43 1
0.1%
15.5 1
0.1%
16.28 1
0.1%
17.75 1
0.1%
ValueCountFrequency (%)
993 1
0.1%
989.8 1
0.1%
985.2 1
0.1%
975 1
0.1%
973.8 1
0.1%
973.7 1
0.1%
972.1 1
0.1%
955.8 1
0.1%
954.4 1
0.1%
906.5 1
0.1%

gross margin percentage
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size7.9 KiB
4.761904762
1000 

Length

Max length11
Median length11
Mean length11
Min length11

Characters and Unicode

Total characters11000
Distinct characters8
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row4.761904762
2nd row4.761904762
3rd row4.761904762
4th row4.761904762
5th row4.761904762

Common Values

ValueCountFrequency (%)
4.761904762 1000
100.0%

Length

2024-04-23T15:27:50.228324image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-23T15:27:50.324526image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
ValueCountFrequency (%)
4.761904762 1000
100.0%

Most occurring characters

ValueCountFrequency (%)
4 2000
18.2%
7 2000
18.2%
6 2000
18.2%
. 1000
9.1%
1 1000
9.1%
9 1000
9.1%
0 1000
9.1%
2 1000
9.1%

Most occurring categories

ValueCountFrequency (%)
(unknown) 11000
100.0%

Most frequent character per category

(unknown)
ValueCountFrequency (%)
4 2000
18.2%
7 2000
18.2%
6 2000
18.2%
. 1000
9.1%
1 1000
9.1%
9 1000
9.1%
0 1000
9.1%
2 1000
9.1%

Most occurring scripts

ValueCountFrequency (%)
(unknown) 11000
100.0%

Most frequent character per script

(unknown)
ValueCountFrequency (%)
4 2000
18.2%
7 2000
18.2%
6 2000
18.2%
. 1000
9.1%
1 1000
9.1%
9 1000
9.1%
0 1000
9.1%
2 1000
9.1%

Most occurring blocks

ValueCountFrequency (%)
(unknown) 11000
100.0%

Most frequent character per block

(unknown)
ValueCountFrequency (%)
4 2000
18.2%
7 2000
18.2%
6 2000
18.2%
. 1000
9.1%
1 1000
9.1%
9 1000
9.1%
0 1000
9.1%
2 1000
9.1%

gross income
Real number (ℝ)

Distinct990
Distinct (%)99.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean15.379369
Minimum0.5085
Maximum49.65
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size7.9 KiB
2024-04-23T15:27:50.446283image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/

Quantile statistics

Minimum0.5085
5-th percentile1.955725
Q15.924875
median12.088
Q322.44525
95-th percentile39.1665
Maximum49.65
Range49.1415
Interquartile range (IQR)16.520375

Descriptive statistics

Standard deviation11.708825
Coefficient of variation (CV)0.76133328
Kurtosis-0.081884758
Mean15.379369
Median Absolute Deviation (MAD)7.50875
Skewness0.8925698
Sum15379.369
Variance137.09659
MonotonicityNot monotonic
2024-04-23T15:27:50.609530image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
10.326 2
 
0.2%
4.464 2
 
0.2%
4.154 2
 
0.2%
9.0045 2
 
0.2%
22.428 2
 
0.2%
39.48 2
 
0.2%
10.3635 2
 
0.2%
8.377 2
 
0.2%
13.188 2
 
0.2%
12.57 2
 
0.2%
Other values (980) 980
98.0%
ValueCountFrequency (%)
0.5085 1
0.1%
0.6045 1
0.1%
0.627 1
0.1%
0.639 1
0.1%
0.699 1
0.1%
0.767 1
0.1%
0.7715 1
0.1%
0.775 1
0.1%
0.814 1
0.1%
0.8875 1
0.1%
ValueCountFrequency (%)
49.65 1
0.1%
49.49 1
0.1%
49.26 1
0.1%
48.75 1
0.1%
48.69 1
0.1%
48.685 1
0.1%
48.605 1
0.1%
47.79 1
0.1%
47.72 1
0.1%
45.325 1
0.1%

Rating
Real number (ℝ)

Distinct61
Distinct (%)6.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean6.9727
Minimum4
Maximum10
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size7.9 KiB
2024-04-23T15:27:50.775507image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/

Quantile statistics

Minimum4
5-th percentile4.295
Q15.5
median7
Q38.5
95-th percentile9.7
Maximum10
Range6
Interquartile range (IQR)3

Descriptive statistics

Standard deviation1.7185803
Coefficient of variation (CV)0.24647271
Kurtosis-1.1515868
Mean6.9727
Median Absolute Deviation (MAD)1.5
Skewness0.0090096488
Sum6972.7
Variance2.9535182
MonotonicityNot monotonic
2024-04-23T15:27:50.908851image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
6 26
 
2.6%
6.6 24
 
2.4%
4.2 22
 
2.2%
9.5 22
 
2.2%
6.5 21
 
2.1%
5 21
 
2.1%
6.2 21
 
2.1%
8 21
 
2.1%
5.1 21
 
2.1%
7.6 20
 
2.0%
Other values (51) 781
78.1%
ValueCountFrequency (%)
4 11
1.1%
4.1 17
1.7%
4.2 22
2.2%
4.3 18
1.8%
4.4 17
1.7%
4.5 17
1.7%
4.6 8
 
0.8%
4.7 12
1.2%
4.8 13
1.3%
4.9 18
1.8%
ValueCountFrequency (%)
10 5
 
0.5%
9.9 16
1.6%
9.8 19
1.9%
9.7 14
1.4%
9.6 17
1.7%
9.5 22
2.2%
9.4 12
1.2%
9.3 16
1.6%
9.2 16
1.6%
9.1 14
1.4%

Interactions

2024-04-23T15:27:44.773958image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
2024-04-23T15:27:40.314430image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
2024-04-23T15:27:41.039060image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
2024-04-23T15:27:41.772452image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
2024-04-23T15:27:42.690277image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
2024-04-23T15:27:43.372994image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
2024-04-23T15:27:44.079353image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
2024-04-23T15:27:44.896056image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
2024-04-23T15:27:40.440130image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
2024-04-23T15:27:41.124810image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
2024-04-23T15:27:41.890407image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
2024-04-23T15:27:42.789865image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
2024-04-23T15:27:43.475466image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
2024-04-23T15:27:44.167626image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
2024-04-23T15:27:44.991150image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
2024-04-23T15:27:40.538819image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
2024-04-23T15:27:41.222060image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
2024-04-23T15:27:42.034333image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
2024-04-23T15:27:42.889822image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
2024-04-23T15:27:43.572942image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
2024-04-23T15:27:44.256438image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
2024-04-23T15:27:45.080635image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
2024-04-23T15:27:40.638777image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
2024-04-23T15:27:41.324250image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
2024-04-23T15:27:42.202399image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
2024-04-23T15:27:42.975925image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
2024-04-23T15:27:43.663016image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
2024-04-23T15:27:44.356664image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
2024-04-23T15:27:45.174267image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
2024-04-23T15:27:40.741081image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
2024-04-23T15:27:41.423545image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
2024-04-23T15:27:42.291213image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
2024-04-23T15:27:43.073525image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
2024-04-23T15:27:43.776433image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
2024-04-23T15:27:44.474088image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
2024-04-23T15:27:45.267932image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
2024-04-23T15:27:40.834924image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
2024-04-23T15:27:41.524660image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
2024-04-23T15:27:42.389556image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
2024-04-23T15:27:43.173158image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
2024-04-23T15:27:43.886236image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
2024-04-23T15:27:44.562369image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
2024-04-23T15:27:45.374950image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
2024-04-23T15:27:40.931067image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
2024-04-23T15:27:41.640208image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
2024-04-23T15:27:42.572502image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
2024-04-23T15:27:43.272791image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
2024-04-23T15:27:43.974875image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
2024-04-23T15:27:44.667094image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/

Missing values

2024-04-23T15:27:45.527234image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-23T15:27:45.740994image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

Sample

Invoice IDBranchCityCustomer typeGenderProduct lineUnit priceQuantityTax 5%TotalDateTimePaymentcogsgross margin percentagegross incomeRating
0750-67-8428AYangonMemberFemaleHealth and beauty74.69726.1415548.97152019-01-0513:08:00Ewallet522.834.76190526.14159.1
1226-31-3081CNaypyitawNormalFemaleElectronic accessories15.2853.820080.22002019-03-0810:29:00Cash76.404.7619053.82009.6
2631-41-3108AYangonNormalMaleHome and lifestyle46.33716.2155340.52552019-03-0313:23:00Credit card324.314.76190516.21557.4
3123-19-1176AYangonMemberMaleHealth and beauty58.22823.2880489.04802019-01-2720:33:00Ewallet465.764.76190523.28808.4
4373-73-7910AYangonNormalMaleSports and travel86.31730.2085634.37852019-02-0810:37:00Ewallet604.174.76190530.20855.3
5699-14-3026CNaypyitawNormalMaleElectronic accessories85.39729.8865627.61652019-03-2518:30:00Ewallet597.734.76190529.88654.1
6355-53-5943AYangonMemberFemaleElectronic accessories68.84620.6520433.69202019-02-2514:36:00Ewallet413.044.76190520.65205.8
7315-22-5665CNaypyitawNormalFemaleHome and lifestyle73.561036.7800772.38002019-02-2411:38:00Ewallet735.604.76190536.78008.0
8665-32-9167AYangonMemberFemaleHealth and beauty36.2623.626076.14602019-01-1017:15:00Credit card72.524.7619053.62607.2
9692-92-5582BMandalayMemberFemaleFood and beverages54.8438.2260172.74602019-02-2013:27:00Credit card164.524.7619058.22605.9
Invoice IDBranchCityCustomer typeGenderProduct lineUnit priceQuantityTax 5%TotalDateTimePaymentcogsgross margin percentagegross incomeRating
990886-18-2897AYangonNormalFemaleFood and beverages56.56514.1400296.94002019-03-2219:06:00Credit card282.804.76190514.14004.5
991602-16-6955BMandalayNormalFemaleSports and travel76.601038.3000804.30002019-01-2418:10:00Ewallet766.004.76190538.30006.0
992745-74-0715AYangonNormalMaleElectronic accessories58.0325.8030121.86302019-03-1020:46:00Ewallet116.064.7619055.80308.8
993690-01-6631BMandalayNormalMaleFashion accessories17.49108.7450183.64502019-02-2218:35:00Ewallet174.904.7619058.74506.6
994652-49-6720CNaypyitawMemberFemaleElectronic accessories60.9513.047563.99752019-02-1811:40:00Ewallet60.954.7619053.04755.9
995233-67-5758CNaypyitawNormalMaleHealth and beauty40.3512.017542.36752019-01-2913:46:00Ewallet40.354.7619052.01756.2
996303-96-2227BMandalayNormalFemaleHome and lifestyle97.381048.69001022.49002019-03-0217:16:00Ewallet973.804.76190548.69004.4
997727-02-1313AYangonMemberMaleFood and beverages31.8411.592033.43202019-02-0913:22:00Cash31.844.7619051.59207.7
998347-56-2442AYangonNormalMaleHome and lifestyle65.8213.291069.11102019-02-2215:33:00Cash65.824.7619053.29104.1
999849-09-3807AYangonMemberFemaleFashion accessories88.34730.9190649.29902019-02-1813:28:00Cash618.384.76190530.91906.6